Cyclistic

Anar Seyf (anar.seyf@gmail.com)
October 2021
Capstone project | Google Data Analytics course #8 | Coursera

The Graphs

Aggregate by day of week

Monthly by weekday

Overall by weekday

## # A tibble: 2 x 4
## # Groups:   dayofweek [1]
##   dayofweek IS_MEMBER AVG_COUNT AVG_DURATION
##       <int> <chr>         <dbl>        <dbl>
## 1         1 false         5047.         26.0
## 2         1 true          7107.         13.4

Hourly

Weekly Counts and Average Duration

Full year, weekly.

##          day IS_MEMBER COUNT AVG_DURATION MIN_DURATION MAX_DURATION
## 1 2020-10-01     false  3247     20.54543            1         1255
## 2 2020-10-01      true  7730     12.22160            1          827
##   STDDEV_DURATION year_month dayofweek weeknum
## 1        43.54311    2020-10         4      40
## 2        16.51734    2020-10         4      40

Note: not weighted average for the graph above.

Monthly by bike type

##   total_count monthly_avg_duration year_month        type is_member
## 1       78447             29.93437    2020-10 docked_bike     false
## 2      152515             13.96272    2020-10 docked_bike      true

The Weather

Weekly

TODO — either use a weather-only dataset or show trips alongside weather.

##   year_week is_member weekly_count weekly_avg_duration weekly_temp_min
## 1   2020-40     false        21188               25.62            6.53
## 2   2020-40      true        31032               13.62            6.53
## 3   2020-41     false        54067               28.55           10.63
##   weekly_temp_avg weekly_temp_max weekly_wind_avg weekly_rain_total
## 1           10.13           13.75            3.23               8.1
## 2           10.13           13.75            3.23               8.1
## 3           16.29           22.86            4.50               0.0
##   weekly_snow_total
## 1                 0
## 2                 0
## 3                 0

TODO: Recompute on new daily aggregates.

##   IS_MEMBER AVG_DURATION COUNT       date temp_avg rain snow wind_avg
## 1     false     21.91015  3250 2020-10-01     11.6  5.3    0      3.8
## 2     false     34.67921  5287 2020-10-02      9.4  0.0    0      3.1

Temperature

In degrees C.

Rain

Rain (mm) vs ride count

Wind

Wind (m/s) vs ride count.

Second graph is scaled to 100% to show member vs casual share.

The Geography

Stations

1288 stations. Following: non-members vs members, 8am vs 4pm, Monday-Friday.

Each dot is a bike docking station. Stations highlighed yellow-red have more arrivals than departures for the given hour, suggesting an influx of bike traffic at that location.